USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[ConsultarLasPracticasProfesor]    Script Date: 01/26/2012 11:48:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ConsultarHorasPracticaProfesor]
(
    @idPractica INT
)
AS
BEGIN
    SET NOCOUNT ON;
    
select HorarioClase.diaSemana,HorarioClase.horaInicio,
HorarioClase.horaFin,Salon.nombre
from practica,HorarioClase,Salon
where Practica.id_Practica = HorarioClase.fk_SeccionPractica
and HorarioClase.fk_Salon = Salon.id_salon
and Practica.id_Practica= @idPractica
END